Insert Column
AutomatR.Excel.Activities.InsertColumn
The "Insert Column" activity in AutomatR is part of the Excel activities package, designed to insert a new column into a table within Microsoft Excel. This activity enhances automation workflows by allowing dynamic adjustments to table structures, improving flexibility in Excel data processing.
Properties
| Name | Description |
|---|---|
| Input | |
| ColumnName | Enter the name for the new column to be inserted in the table. String variables containing the column name. |
| Position | Specify the position for inserting the new column or leave it blank to take the next available column in the table design. Integer variables containing the position index. |
| TableName | Enter the name of the table where the new column will be inserted. String variables containing the table name. |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Enter the wait time in seconds (Example 5 seconds, i.e., 5) to start the activity. Integer variables containing the delay duration. |
How to use:
- Drag and drop the "Insert Column" activity onto the workflow.
- Configure the properties by specifying the table name, new column name, and optional position.
- Optionally, configure the delay.
- Execute the workflow to insert the new column into the specified table.
Example: Consider an example where the "Insert Column" activity is used to insert a new column named "Sales" into a table named "SalesData" at the third position:
Insert Column:
TableName: "SalesData"
ColumnName: "Sales"
Position: 3
Delay: 2
In this example, the activity inserts a new column named "Sales" into the "SalesData" table at the specified position. The delay is set to 2 seconds, allowing time for any required synchronization.
Note: Ensure that the "Insert Column" activity is placed within an "Excel Root" activity to establish the Excel context for execution.